EMT Practice Test

1. Question Content...

---

Question1: A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

Question2: Why would you enable Debug Query mode in a calculation view?

Question3: In a database module, what is the purpose of the .hdiconfig file?

Question4: What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

Question5: What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

Question6: Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

Question7: You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

Question8: You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

Question9: Which components are part of SAP HANA Cloud?Note: There are 2 correct answers to this question.

Question10: Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

Question11: Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

Question12: Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

Question13: You create a user-provided service to access tables in external schemas.In which file type do you assign the user-provided service to your database module?

Question14: Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

Question15: What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

Question16: You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

Question17: You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Question18: You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

Question19: In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

Question20: Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

Question21: You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

Question22: Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

Question23: A calculation view includes a rank node that uses the source data and settings shown in the graphic.

Your query requests all columns of the rank node.How many rows are in the output of your query?

Question24: When is the first column store compression executed?

Question25: What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

Question26: You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Question27: You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.